UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vJrP+a/l2QYFh+KLMto3Ec14AEIkMSRfzaj0zYZP2t0='
WHERE
key_id = '2a714eb470ed76385fc67b2ea63f5f7cda63fcd383dc62dd86fd4068b10870de'
AND (
token = 'vJrP+a/l2QYFh+KLMto3Ec14AEIkMSRfzaj0zYZP2t0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)