UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oze16GHoN9OVcxYuv/TxwTc5U3GAYUVYY6J6RjGHhXU='
WHERE
key_id = '7b390016a4f81e02979c44135e22f08b2ae68f9789673baab11e111524c2b187'
AND (
token = 'oze16GHoN9OVcxYuv/TxwTc5U3GAYUVYY6J6RjGHhXU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)