UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bcLQsHTUfYrT22wnmbjClPFal655Y7N79LHS0s9eIow='
WHERE
key_id = '2ff2427c7191fa2f5c879fb330c1ef05cc2c8295f80e2395ebf220665c1f19df'
AND (
token = 'bcLQsHTUfYrT22wnmbjClPFal655Y7N79LHS0s9eIow='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)