UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XB6GGMhDfkx0NH5uxUf5mOAnAZTAYAssmK363+xrUFs='
WHERE
key_id = '315679b3f796fb9affb0c91d1292841ee797256c826afc69e5b8d42e4631a3a2'
AND (
token = 'XB6GGMhDfkx0NH5uxUf5mOAnAZTAYAssmK363+xrUFs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)