UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2ZJw1OGCofz3vZ8PX3wJ9t07J/8mmQGOQ38fdzFBS38='
WHERE
key_id = '697e5e3318321ebb9f7acf0d58eef572b5ba0ef5d91ccce2332ee13b3a2f8fda'
AND (
token = '2ZJw1OGCofz3vZ8PX3wJ9t07J/8mmQGOQ38fdzFBS38='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)