UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9RNIzzcP5+bkPD6uYNdsI0gdGioDZae3ESO9sDGi+0k='
WHERE
key_id = '819178f2d897f7dec5061ed5318e86bf8946c576dc7491dc58d67360c27e9da4'
AND (
token = '9RNIzzcP5+bkPD6uYNdsI0gdGioDZae3ESO9sDGi+0k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)