UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8R4Nuxx4cO0713wWEky7IrhJ8WiLGk4E7viTG41mxlI='
WHERE
key_id = 'ca345a03e167d1609c29a8834e0924906cfa59cd2fabfa4f2d347751242932b4'
AND (
token = '8R4Nuxx4cO0713wWEky7IrhJ8WiLGk4E7viTG41mxlI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)