UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XFOhF9J3oGlCGBdCDhjB5PIYQb42+aiefhhTpzog4i8='
WHERE
key_id = 'a8f85f355a907e8e495a7c613bd19088045156d0e92e56d0aa1e031a257a216c'
AND (
token = 'XFOhF9J3oGlCGBdCDhjB5PIYQb42+aiefhhTpzog4i8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)