UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zB9WzPSdZi7y7za5OXj4kpqVALDTrQeGHTbH6PTSgX0='
WHERE
key_id = '5ac43c2d4ffe5624b74276cb82f771a8a4a16d1808dbd8a29b5b83e930552b77'
AND (
token = 'zB9WzPSdZi7y7za5OXj4kpqVALDTrQeGHTbH6PTSgX0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)