UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mEYn0xI3MNk92vunq+mk30atowHNA8CZDPddu8HTHCU='
WHERE
key_id = 'cb272da61370673666a8c349dec81951c89a50c1bae5cd0ff40e088206e36e07'
AND (
token = 'mEYn0xI3MNk92vunq+mk30atowHNA8CZDPddu8HTHCU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)