UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1sIKvRY3FjePJUINBGb7V2+727BBCf/7HQRYxwzYpVA='
WHERE
key_id = 'e4d9bb5a6b544d3f5a01e4ab4e1cc065706ffc2341a97191d763b8f4f8db2121'
AND (
token = '1sIKvRY3FjePJUINBGb7V2+727BBCf/7HQRYxwzYpVA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)