UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TK3ofg9OgiklOUStbTWNNtB3SkwKRS9eV4lxEfLpsCA='
WHERE
key_id = '52a1a78ac7e06c50b897e856064c97e52aff1bb172005a09fea1c70b2b475037'
AND (
token = 'TK3ofg9OgiklOUStbTWNNtB3SkwKRS9eV4lxEfLpsCA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)