UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ACvRvqRAUdk6wvdVunCYc4TQt8zf0Z4QIDazM0aqkzs='
WHERE
key_id = 'f31c21a976f107380ceef68a1f5136be7ab78687aaa211e2beab597f1395780d'
AND (
token = 'ACvRvqRAUdk6wvdVunCYc4TQt8zf0Z4QIDazM0aqkzs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)