UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QNIKpZUmehh5YhQrLp2ex0tXff410HgQ/rvb80ahwlA='
WHERE
key_id = 'e65f29599fc043328c4a8ba99e7d8cfde84e7590358bbaf6a14d76061672a4ec'
AND (
token = 'QNIKpZUmehh5YhQrLp2ex0tXff410HgQ/rvb80ahwlA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)