UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S3ZoMiiH22OxZ2FCljZNJUdafDgRXWWF0D58bjirJ28='
WHERE
key_id = 'b65777ca48802852ec08b09e742d5d19b03a5b1e7ec1b0bfc5afb1ef7f52bf1a'
AND (
token = 'S3ZoMiiH22OxZ2FCljZNJUdafDgRXWWF0D58bjirJ28='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)