UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gBRqe1foqsG6ImjtpgaMV4lp9x7uF635JwTe/pv6h/M='
WHERE
key_id = '5b734dad73812e7bf36679fa606e228f6c346c7e27c99971f564ef7739ffac92'
AND (
token = 'gBRqe1foqsG6ImjtpgaMV4lp9x7uF635JwTe/pv6h/M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)