UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5AlZc9IZCpXnWizxLQ2YGYzfoCWK7H6YN6YlNSELOuc='
WHERE
key_id = '12184e1d5a112861513ff8ae440e3b31be3c5af517e94412debad2f7d0ff6dda'
AND (
token = '5AlZc9IZCpXnWizxLQ2YGYzfoCWK7H6YN6YlNSELOuc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)