UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZKiSFe9tyfvYjRVHSfvhObwdPu/xW11JuxngnrG5LlU='
WHERE
key_id = '49192982a342e1136b65f221904fe5adcd84f906fc59069220563dda039a73b5'
AND (
token = 'ZKiSFe9tyfvYjRVHSfvhObwdPu/xW11JuxngnrG5LlU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)