UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5vUMWZeK7h8fGlr3jwPAAMDpb6beNDb4tGjRnSXsDaQ='
WHERE
key_id = 'd2ccca2a0caa7d016e0b3c0574a617208ab293f1c1d6bccbba418da45cb21106'
AND (
token = '5vUMWZeK7h8fGlr3jwPAAMDpb6beNDb4tGjRnSXsDaQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)