UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LRNQhcIn34wUtvNfthnyWfe/VepzlL0w6Scot0D/N+E='
WHERE
key_id = 'c549b5b83ee4134fcffcf1cccc99c7f3da8012a80cc270543ab60e5fb5910299'
AND (
token = 'LRNQhcIn34wUtvNfthnyWfe/VepzlL0w6Scot0D/N+E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)