UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C6iWzSdVbu7ARIR4K9DxoTAAX5yXSB9D36zetLvc3/I='
WHERE
key_id = 'd52d939d7e8852edd9921b94c838a01bc7eb2bb3d85f1d84d8763a02e345378f'
AND (
token = 'C6iWzSdVbu7ARIR4K9DxoTAAX5yXSB9D36zetLvc3/I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)