UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oFpPmMIKMjINYR5wdbzoOUgiGlCn5N2IEosT9E6mvh8='
WHERE
key_id = '1c071dc90eab865a40b81d5e9037697c8d4154d56c0e1994696a96bc35904416'
AND (
token = 'oFpPmMIKMjINYR5wdbzoOUgiGlCn5N2IEosT9E6mvh8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)