UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zH1se71vVjwFWB/70x/fUah69TayQIjMjaEn/JSOE3c='
WHERE
key_id = 'c25b242a7851c90abf73c59880b04956f416b3c72e18e7f49c5e78eada24f601'
AND (
token = 'zH1se71vVjwFWB/70x/fUah69TayQIjMjaEn/JSOE3c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)