UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '27jWwXo/W7h19QUHzv4vxl1UPuIuBElzuRnwd2YgwWc='
WHERE
key_id = '5263e5b334dcd4900201c268514dbed9e50bdc6f5cc0ac035fb703f38bf2f7eb'
AND (
token = '27jWwXo/W7h19QUHzv4vxl1UPuIuBElzuRnwd2YgwWc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)