UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bphTZ4GZlLBt9Mq9z4vc8MXypaDjst1ZbUmFj8hpNBU='
WHERE
key_id = 'e3f0bb19b80ca0a84afa48b71915682885a75f9053baba84540b256f6fc9e5f1'
AND (
token = 'bphTZ4GZlLBt9Mq9z4vc8MXypaDjst1ZbUmFj8hpNBU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)