UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HOQfNLJ+iezjKswu6TVJ8NAbSFknlg1CCp7RQ20fktE='
WHERE
key_id = 'e338e195455721d9cf587863b271277bdff0825c23e31be8a3cdfb83e0eec031'
AND (
token = 'HOQfNLJ+iezjKswu6TVJ8NAbSFknlg1CCp7RQ20fktE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)