UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z8dhVNrHd4QbQEK0cbA6sWRgkm1R7AOBvnwECgdfNZ4='
WHERE
key_id = '6f4404fce0cad9bd33c0f46bb81dce1509c51df441de49d85982f45cb86d003f'
AND (
token = 'z8dhVNrHd4QbQEK0cbA6sWRgkm1R7AOBvnwECgdfNZ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)