UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xl1THbsOIjeSNlkJCpX+WtHDQpPgtR171Q8lg75xrTU='
WHERE
key_id = '09cad54152fb99b12bd3b4006c67f8ea70ca677230e01db39e23bf4a45345fc9'
AND (
token = 'Xl1THbsOIjeSNlkJCpX+WtHDQpPgtR171Q8lg75xrTU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)