UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yhpS8lpbgFA2Iy0LqkC6oudf50l+7em0X2jCj4Nhpxs='
WHERE
key_id = 'f55f87495ae2f4d952c86727e6d704caea6543f306f49d0028e50f27e7014579'
AND (
token = 'yhpS8lpbgFA2Iy0LqkC6oudf50l+7em0X2jCj4Nhpxs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)