UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2zcprDqirIO5f4gj95zpxu35+8vHWciVC3eit86XNdw='
WHERE
key_id = 'c14dbdcfd4e2c4f8587f07b30a8c94f427bc65f635a3154d48419b9c95c17d58'
AND (
token = '2zcprDqirIO5f4gj95zpxu35+8vHWciVC3eit86XNdw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)