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