UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qThxH9psYQcu3a68Ntq3gpbZAR26mf6/jIbq2siuBO8='
WHERE
key_id = '2a0a3a1eb95d6ece89d001a0d6b71ce73b98cc054c7070ea7b12cbaf66dbd29b'
AND (
token = 'qThxH9psYQcu3a68Ntq3gpbZAR26mf6/jIbq2siuBO8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)