UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1I4aaOZ5ls3dpIDnSIc9Jq8ZqTYtyUn1bB0PT6/U06k='
WHERE
key_id = 'ef2912e396ddee5f1bb4834c141844574e852f99745fe6298e8595dc38b4ef7f'
AND (
token = '1I4aaOZ5ls3dpIDnSIc9Jq8ZqTYtyUn1bB0PT6/U06k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)