UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4e2bAujt9i+ZRtV6jF7aBolN8Hia6CZFaGymnRsffWc='
WHERE
key_id = '31fbc5ec0c085de793ae18b4b766ec55398596b95a82b5eaeadbb440074a5831'
AND (
token = '4e2bAujt9i+ZRtV6jF7aBolN8Hia6CZFaGymnRsffWc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)