UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5QmDuVWHQ8+XkJjej+FB8zVsm6gucTqoSjr2z47RGCw='
WHERE
key_id = '3e989fca9e106111170457f5e134f93ae3c13e5cd4bff66d10d6b733c09d2822'
AND (
token = '5QmDuVWHQ8+XkJjej+FB8zVsm6gucTqoSjr2z47RGCw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)