UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zv0seKfsV/b4lZlGqBPXNozangdgWiEIlQIiHorcLWg='
WHERE
key_id = 'd9e7ce4df29a10b747a8fc3332d40ae0ce2f559d4517329cf949e46efa65bfdf'
AND (
token = 'Zv0seKfsV/b4lZlGqBPXNozangdgWiEIlQIiHorcLWg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)