UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SnSxfXbQ6tP4WZHl8evycykDjVGOYluskhgPc1L2HCo='
WHERE
key_id = '77c2bb7e2a03838f59b81ff54c666b8d37739b54288a8f7398d7624717092fa9'
AND (
token = 'SnSxfXbQ6tP4WZHl8evycykDjVGOYluskhgPc1L2HCo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)