UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3iBiincNUtvqzNHDHwbjccHAqr/ghTsEnHdY4VA5cus='
WHERE
key_id = 'ab7dc5cd8ede40e8b13bd4bad79a4b82f39f80f74173a4be16e9ba5742661a18'
AND (
token = '3iBiincNUtvqzNHDHwbjccHAqr/ghTsEnHdY4VA5cus='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)