UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'If4ffngaU6Nsykghp4TqC3Flh553DZ48/RGj7jhe/qU='
WHERE
key_id = 'b3d1d02387ada99ac10807be799a1c3032b7c4abcbec48ccdfd5304bd4ba3783'
AND (
token = 'If4ffngaU6Nsykghp4TqC3Flh553DZ48/RGj7jhe/qU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)