UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zk8NKOKsQB61jsWAg3z+KhUlyuwC4J7gihGTCGzhyOg='
WHERE
key_id = '9d15d2c4f02cbf97977a57363e4570e0c6ed406f7b3a3e9e5e4f28412683b1ee'
AND (
token = 'Zk8NKOKsQB61jsWAg3z+KhUlyuwC4J7gihGTCGzhyOg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)