UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0529B4ZwFzmOyO/eVGCb33JSvBLrv3zZVhLYkuG6CMI='
WHERE
key_id = 'b203f07e23a8988905a7a186534820897d4c134760c89f68c5ac5176c6f5bf3d'
AND (
token = '0529B4ZwFzmOyO/eVGCb33JSvBLrv3zZVhLYkuG6CMI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)