UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XyIdN0J+0iaxAq2EozkrOnvA7QPFhls3vNvl5sbkbMI='
WHERE
key_id = 'e014e8d6f56bb6e0ddd4ee2a35875571d43e32bf6bd43087489c3293ba6c2234'
AND (
token = 'XyIdN0J+0iaxAq2EozkrOnvA7QPFhls3vNvl5sbkbMI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)